package com.woniu.mapper;

import com.woniu.entity.FlowerInfo;
import com.woniu.vo.FlowerInfoVoCZT;
import org.apache.ibatis.annotations.Param;
import com.woniu.vo.FlowerInfoVo;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface FlowerInfoMapper extends Mapper<FlowerInfo> {
    
    List<FlowerInfoVo>  selectAllFlowerInfo(String flowerName,String startTime,String endTime,Integer isDelete);
    FlowerInfoVoCZT selectFlowerInfoByFlowerId(int flowerId);

    List<FlowerInfo> sortFlowerInfoBySearchNameAndSortOrder(@Param("searchName") String searchName,
                                                            @Param("sortProperty") String sortProperty,
                                                            @Param("sortOrder") String sortOrder
//                                                            @Param("PageNum") String PageNum,
//                                                            @Param("PageSize") String PageSize
    );
    /*LIMIT ${PageNum}, ${PageSize}*/

    List<FlowerInfoVo>  selectAllFlowerInfo();

}